C:/Projekte/RAIS/common/QueryParameter.cs

Go to the documentation of this file.


using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

using QueryParameterTypes = System.Collections.Generic.Dictionary<string, RAIS.Common.TableManagement.QueryParameter.QueryParameterTypeData>;
//using QueryParameterTypes = System.Collections.Generic.Dictionary<RAIS.Common.TableManagement.QueryParameter.QueryParameterType, RAIS.Common.TableManagement.QueryParameter.QueryParameterTypeData>;

namespace RAIS.Common.TableManagement
{
        public class QueryParameter: DBObject
        {
                //*********************************************************************
                #region Enumerators
                public enum QueryParameterType
                {
                        Unknown,
                        Lookup,
                        LookupFromTable,
                        LookupFromQuery,
                        DatesRangeStartDate,
                        DatesRangeEndDate,
                        PrimaryKey,
                        Text,
                        Integer,
                        Rational,
                        Date,
                        PreselectedFacility,
                        PreselectedDepartment,
                        UserID,
                        Xml
                }
                #endregion
                //*********************************************************************
                #region Fields
                static QueryParameterTypes queryParameterTypesDictionary;

                string visibleName;
                QueryParameterType type = QueryParameterType.Unknown;
                Table table;
                Query relatedQuery;
                int order;
                #endregion
                //*********************************************************************
                #region Properties
                public static QueryParameterTypes QueryParameterTypesDictionary
                {
                        get { return QueryParameter.queryParameterTypesDictionary; }
                        set { QueryParameter.queryParameterTypesDictionary = value; }
                }

                public string VisibleName
                {
                        get { return this.visibleName; }
                        set { this.visibleName = value; }
                }
                public QueryParameterType Type
                {
                        get { return this.type; }
                        set { this.type = value; }
                }
                public QueryParameterTypeData TypeData
                {
                        get { return queryParameterTypesDictionary[this.TypeText]; }
                }
                public string TypeText
                {
                        get
                        {
                                string result = string.Empty;
                                foreach (KeyValuePair<string, QueryParameterTypeData> queryParameterTypeItem in queryParameterTypesDictionary)
                                        if (queryParameterTypeItem.Value.Type == this.type)
                                        {
                                                result = queryParameterTypeItem.Value.VisibleName;
                                                break;
                                        }
                                return result;
                        }
                        set
                        {
                                this.type = queryParameterTypesDictionary[value].Type;
                        }
                }
                public Table Table
                {
                        get { return this.table; }
                        set { this.table = value; }
                }
                public Query RelatedQuery
                {
                        get { return this.relatedQuery; }
                        set { this.relatedQuery = value; }
                }
                public int Order
                {
                        get { return this.order; }
                        set { this.order = value; }
                }
                public string DBObjectName
                {
                        get
                        {
                                string name = string.Empty;
                                if (this.relatedQuery != null)
                                {
                                        name = this.relatedQuery.Name;
                                }
                                else
                                {
                                        if (this.table != null)
                                                name = this.table.Name;
                                }
                                return name;
                        }
                }
                #endregion

                //*********************************************************************
                #region Constructors
                public QueryParameter()
                { }

                public QueryParameter(IDataRecord record)
                {
                        this.id = (int)record["PK Query Parameter ID"];
                        this.name = record["Query Parameter Name"].ToString();
                        this.type = (QueryParameterType)Enum.Parse(typeof(QueryParameterType), record["Query Parameter Type Name"].ToString());
                        if (!(record["FK Table ID"] is DBNull))
                        {
                                this.table = new Table();
                                this.table.ID = (int)record["FK Table ID"];
                        }
                        if (!(record["FK Related Query ID"] is DBNull))
                        {
                                this.relatedQuery = new Query();
                                this.relatedQuery.ID = (int)record["FK Related Query ID"];
                        }
                        this.order = (int)record["Order"];
                        this.visibleName = record["Visible Name"].ToString();
                }
                #endregion 
                //*********************************************************************
                #region Nested classes
                public class QueryParameterTypeData : DBTypeObject
                {
                        //*********************************************************************
                        #region Properties
                        public QueryParameterType Type
                        {
                                get { return (QueryParameterType)Enum.Parse(typeof(QueryParameterType), this.name); }
                        }
                        public bool ParameterTypeForFilters
                        {
                                get
                                {
                                        bool parameterForFilters = false;
                                        if (this.Type == QueryParameterType.Unknown
                                                // The possibility to use just table (not query) for filter has not implemented yet
                                                // that's why LookupFromTable parameter type is commented
                                                //|| this.Type == QueryParameterType.LookupFromTable
                                                || this.Type == QueryParameterType.LookupFromQuery
                                                || this.Type == QueryParameterType.DatesRangeStartDate
                                                || this.Type == QueryParameterType.DatesRangeEndDate
                                                || this.Type == QueryParameterType.PreselectedFacility
                                                || this.Type == QueryParameterType.PreselectedDepartment
                                                || this.Type == QueryParameterType.UserID
                                        )
                                        {
                                                parameterForFilters = true;
                                        }
                                        return parameterForFilters;
                                }
                        }
                        public bool ParameterTypeForOthers
                        {
                                get
                                {
                                        bool parameterForOthers = false;
                                        if (this.Type == QueryParameterType.Unknown
                                                || this.Type == QueryParameterType.Date
                                                || this.Type == QueryParameterType.Integer
                                                || this.Type == QueryParameterType.Lookup
                                                || this.Type == QueryParameterType.PrimaryKey
                                                || this.Type == QueryParameterType.Rational
                                                || this.Type == QueryParameterType.Text
                                                || this.Type == QueryParameterType.UserID
                                                || this.Type == QueryParameterType.Xml
                                        )
                                        {
                                                parameterForOthers = true;
                                        }
                                        return parameterForOthers;
                                }
                        }
                        #endregion
                        //*********************************************************************
                        #region Constructors
                        public QueryParameterTypeData()
                        { }

                        public QueryParameterTypeData(IDataRecord record)
                        {
                                this.id = (int)record["PK Query Parameter Type ID"];
                                this.name = record["Query Parameter Type Name"].ToString();
                                this.visibleName = record["Query Parameter Type Visible Name"].ToString();
                        }
                        #endregion
                }
                #endregion
        }
}